package com.hxgis.statisticanalysis.intelligentIndicator.dao.jpa;


import com.hxgis.statisticanalysis.intelligentIndicator.pojo.FailureMapping;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface FailureMappingJpa extends JpaRepository<FailureMapping, Long> {

    @Query(value = "SELECT * FROM `equipment_failure_mapping` GROUP BY station_no", nativeQuery = true)
    List<FailureMapping> getAllMapping();
}
